Prev

Next

Author: Paul Kravchenko
Posted: 8/6/2010 12:00:00 PM

Question:

Is it possible to encrypt Username and Password in SQL connection strings?

Answer:

There are two possible approaches:

1) Setup trusted SQL connection to avoid specifying the credentials in the connection strings, please refer the following article:

http://sitecoreblog.alexshyba.com/2008/12/changing-application-pool-identity-for.html

2) Move the Connection strings to the web.config file from /App_Config/ConnectionStrings.config file and use standard ASP.NET encryption to encrypt the connection strings, please refer the following article:

http://msdn.microsoft.com/en-us/library/ms998280

Prev

Next